Orbital Results

When you run a query or script, their results will be listed in the Results page. The Results page is an aggregated overview list of all of the results from the all of the queries and scripts that have completed or are actively running.

IMPORTANT:

Results are only retained in Orbital for 48 hours, after which the results expire. If the results have expired, you cannot retrieve them. This is why important data should be sent to a remote data store, so that they are available after the expiration date. Refer to the Setting Up Remote Data Stores topic for more information on managing your remote data stores.

If you need to see results that are expired, you will need to recreate the scheduled query or script with a new name, or recreate the query or script and save it.

Results Page

Queries and scripts can be run on the fly as custom queries and scripts. They can also be saved as scheduled queries and scripts to be run on a regular, predetermined basis with the results being sent to an external application or a specified remote data store.

The Results page lists all the results from one or more queries or scripts.

This page consists of:

Download JSON

Click the Download JSON icon to download the Results page table as a JSON file.

 

Note: The maximum number of script results records that can be downloaded is 10,000 records.

 

Refreshed

Refresh the list of results.

 

Click the Refresh button () to refresh the results list. This will update the date displayed the beside the Refresh button to display the date and time that the results list was last refreshed.

Click the date and time to display the Time Setting drop down:

 

Refresh Time

Lists the amount of time between the time and date that the endpoint list was last refreshed and the current time and date. For example, 7 minutes ago or an hour ago.

 

Copy Refresh Time

Copy the time of the last endpoint list refresh in UTC. For example; 2024-04-10 18:37:15

 

Copy Unix Refresh Time Stamp

Copy the time of the last endpoint list refresh in the UNIX time stamp format. For example; 1712774235

 

Change time preferences Link

Open the My Account page, where you can change the default Time Options. See the Time Options interface section of My Account Page.

Filters

This element displays the filters that are available for use with the query and script results listed on this page. The available filters act on how the script will be run.
  Filter Group Filter Description
 

Type Filters

Query

Selecting this filter will force Orbital to list only those results that occur as a result of queries.
   

Script

Selecting this filter will force Orbital to list only those results that occur as a result of scripts.
 

Frequency Filters

Scheduled

Selecting this filter will force Orbital to list only those results that are the result of scheduled queries and scripts.
   

Non-scheduled

Selecting this filter will force Orbital to list only those results that are the result of non-scheduled queries and scripts.
  You can mix and match these filters. For example, you can select the Query filter and the Scheduled filter, and Orbital will display only those results that are from scheduled queries.

Hide/Show Filters

This element will either hide or display the Filters pane. If the Filters pane is displayed, clicking Hide Filters () will collapse the Filters pane. If the Filters pane is hidden, clicking Show Filters () expand the Filters pane.

Name

This column displays the name of the query or script being run or has been run.

Click on the query or script Name link to open the Detailed Results page, discussed in the Results Details topic.

Click the vertical dots to open the action menu. Options include: Rename, Copy URL, Copy ID, Reuse, Stop. If the script has expired or is an ad hoc script, the Stop option will be unavailable.

Status

This column displays the current status of the queries and scripts. A percentage gauge is added for active queries or scripts, showing how much has been completed.

 

Scheduled Query Run Time Display

While a scheduled query or script is running, the Status column of the Results page displays a progress indicator.

 

This indicator shows that the query or script is still running and is actively returning results. On the right side of this status display is the Time Remaining display.

This display shows the time remaining before the query or script finishes. The format it takes is: dd:hh:mm:ss:

where:

  • dd = number of days remaining in the query or script's run.

  • hh = number of hours remaining in the query or script's run.

  • mm = number of minutes remaining in the query or script's run.

  • ss = number of seconds remaining in the query or script's run.

Catalog

This column displays the specific catalog used by the query or script. If the query or script being run is a catalog query or script, you can click the name of the catalog query or script to see the details of that query or script. If the query or script is a custom query or script, the string Custom will appear in this column.

Endpoints

The total endpoint count in the query or script's results out of the total possible endpoints.

Results

The number of records that are returned in the results.

Errors

The number of errors returned by the query or script run.

Result Rows

The number of rows in the query or script's results.

Frequency

Shows whether the query or script was Scheduled or Non-scheduled.

Type

Shows whether the action is a query or a script.

Source

Displays whether the script is a custom script or a stock (catalog) script.

Created

The date and time the query or script was created.

Creator

The user who created and ran the query or script.

More Info